import openpyxl
myBook=openpyxl.load_workbook('城市排名表.xlsx')
mySheet=myBook.active
myRows=list(mySheet.rows)[1:]
for myRow in myRows:
	myList=[]
	myNames=myRow[1].value.split('、')
	for myName in myNames:
		if myName not in myList:
			myList.append(myName)
	myRow[1].value='、'.join(myList)
myBook.save('结果表-城市排名表.xlsx')
